CREATE EXTERNAL TABLE jms_dwd.dwd_yl_tmsnew_branch_shipment_stop_base_hi(
  `id` bigint COMMENT '经停点编码', 
  `shipment_id` bigint COMMENT '任务ID', 
  `shipment_no` string COMMENT '任务编号', 
  `sort_num` bigint COMMENT '顺序编号', 
  `network_id` bigint COMMENT '经停网点ID', 
  `network_code` string COMMENT '经停网点编号', 
  `network_name` string COMMENT '经停网点名称', 
  `roadsection_id` bigint COMMENT '路段编号', 
  `planned_arrival_day` string COMMENT '计划到达日期', 
  `planned_arrival_hour` string COMMENT '计划到达时间', 
  `planned_arrival_time` timestamp COMMENT '计划到达日期+时间', 
  `actual_arrival_time` timestamp COMMENT '实际到达时间', 
  `planned_departure_day` string COMMENT '计划离开日期', 
  `planned_departure_hour` string COMMENT '计划离开时间', 
  `planned_departure_time` timestamp COMMENT '计划离开日期+时间', 
  `actual_departure_time` timestamp COMMENT '实际离开时间', 
  `stop_time` bigint COMMENT '经停时长', 
  `usetime` bigint COMMENT '运输耗时(MIN)', 
  `mileage` double COMMENT '规划里程(KM)', 
  `speed` double COMMENT '时速(KM/H)', 
  `batch_time` string COMMENT '批次时间', 
  `handling_type` string COMMENT '装卸类型', 
  `load_start_time` timestamp COMMENT '开始装货', 
  `load_end_time` timestamp COMMENT '装货完成', 
  `unload_start_time` timestamp COMMENT '开始卸货', 
  `unload_end_time` timestamp COMMENT '卸货完成', 
  `app_arrival_time` timestamp COMMENT 'APP到达时间', 
  `app_departure_time` timestamp COMMENT 'APP离开时间', 
  `gps_arrival_time` timestamp COMMENT 'GPS到达时间', 
  `gps_departure_time` timestamp COMMENT 'GPS离开时间', 
  `lock_time` timestamp COMMENT '锁车时间', 
  `unlock_time` timestamp COMMENT '解锁时间', 
  `weight_arrival_time` timestamp COMMENT '过磅进站时间', 
  `weight_departure_time` timestamp COMMENT '过磅出站时间', 
  `arrival_gross_weight` double COMMENT '到达毛重', 
  `arrival_tare_weight` double COMMENT '到达皮重', 
  `arrival_net_weight` double COMMENT '到达净重', 
  `departure_gross_weight` double COMMENT '离开毛重', 
  `departure_tare_weight` double COMMENT '离开皮重', 
  `departure_net_weight` double COMMENT '离开净重', 
  `estimate_arrival_time` timestamp COMMENT '预计到达时间=上一站实际发车时间+本站运输耗时(MIN)', 
  `plan_driving_time` bigint COMMENT '规定行驶时间', 
  `actual_driving_time` bigint COMMENT '实际行驶时间', 
  `actual_arrival_time_source` string COMMENT '实际进站时间来源', 
  `actual_departure_time_source` string COMMENT '实际出站时间来源', 
  `estimate_batch_time` timestamp COMMENT '应赶批次', 
  `actual_batch_time` timestamp COMMENT '实赶批次时间', 
  `create_by` bigint COMMENT '创建人ID', 
  `create_by_name` string COMMENT '创建人姓名', 
  `create_time` timestamp COMMENT '创建时间', 
  `update_by` bigint COMMENT '更新人ID', 
  `update_by_name` string COMMENT '更新人姓名', 
  `update_time` timestamp COMMENT '更新时间', 
  `simple_name` string COMMENT '网点简称', 
  `gps_depart_mileage` double COMMENT 'GPS发车里程', 
  `gps_arrival_mileage` double COMMENT 'GPS到车里程', 
  `financial_center_id` bigint COMMENT '代理区ID', 
  `financial_center_code` string COMMENT '代理区CODE', 
  `financial_center_desc` string COMMENT '代理区名称', 
  `clock_time` timestamp COMMENT '中心签到时间')
COMMENT '支线任务经停表'
PARTITIONED BY ( 
  `dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS parquet 
LOCATION
  '/dw/hive/jms_dwd.db/external/dwd_yl_tmsnew_branch_shipment_stop_base_hi';